Release 10.1A: OpenEdge Development:
Java Open Clients

Passing Temp-tables as SQL ResultSet Parameters

Progress 4GL client procedures can pass static (TABLE) or dynamic (TABLE-HANDLE) temp-table parameters to an AppServer. This is a convenient and efficient way to pass a table of relational data between the client and an OpenEdge application service. The Java Open Client provides the same capability using a SQL ResultSet object. A Java Open Client can thus pass the SQL ResultSet object as a parameter mapped to the specified temp-table parameter in the application service. The Open Client uses the same Java class to map both static and dynamic temp-table parameters. For more information on static and dynamic temp-tables, see Chapter 4, " Passing Parameters."

Note: You can also map and pass temp-table parameters as ProDataGraph objects. For more information, see Chapter 5, " Accessing Progress ProDataSets."

The following sections provide information on:

Preparing and managing temp-table parameters
SQL ResultSet streaming and call-back sequence
Passing a TABLE or TABLE-HANDLE as an INPUT parameter
Passing a TABLE or TABLE-HANDLE as an OUTPUT parameter
Passing a TABLE or TABLE-HANDLE as an INPUT-OUTPUT parameter